---TAB_TERMINAL_SECRET
CREATE EXTERNAL TABLE jms_ods.tab_terminal_secret(
  `app_id`                bigint        COMMENT '应用id',
  `corp_id`             string        COMMENT '组织id',
  `business_name`         string        COMMENT '品牌name',
  `business_id`         int            COMMENT '品牌id',
  `secret`                 string        COMMENT '64位加密串',
  `scan_pda`            string        COMMENT '扫描pda编码',
  `remark`                 string        COMMENT '备注',
  `user_code`             string        COMMENT '用户code',
  `user_name`             string        COMMENT '用户name',
  `create_time`         string        COMMENT '创建时间',
  `access_time`         string        COMMENT '访问时间',
  `use_status`             string        COMMENT '用户状态',
  `pdd_code`            string        COMMENT '拼多多映射编码',
  `pdd_return_code`     string        COMMENT '拼多多回传映射编码',
  `pdd_return_name`     string        COMMENT '拼多多回传映射名称',
  `filter_flag`         int            COMMENT '是否过滤，1过滤，2不过滤'
  )
COMMENT '末端信息映射表表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区(yyyy-MM-dd)')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_ods.db/external/tab_terminal_secret'
TBLPROPERTIES (
        'parquet.column.index.access' = 'true'
        );